﻿/*
{
"状态":1,
"名称":"修改-BI日期数据",
"作者":"马学兵",
"创建时间":"2019-02-19",
"功能":"修改-BI日期数据",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/

declare @dkey int 
declare @daytype nvarchar(50)				--日期类型
declare @holidaytype nvarchar(50)			--国定假日
declare @otherholidaytype	 nvarchar(50)				--其他假日
declare @comparisondate	 date					--比较日期
declare @coefficient	 numeric(18,2)					--系数
declare @solarterms	nvarchar(50)						--节气
 
set @dkey='{dkey}'
set @daytype='{daytype}'
set @holidaytype='{holidaytype}'
set @otherholidaytype='{otherholidaytype}'
set @comparisondate='{comparisondate}'
set @coefficient='{coefficient}'
set @solarterms='{solarterms}'
 
 update EIDW.dbo.b_date set 
 daytype=@daytype,
 holidaytype=@holidaytype,
 otherholidaytype=@otherholidaytype,
 comparisondate=@comparisondate,
 coefficient=@coefficient,
 solarterms=@solarterms
 where dkey=@dkey
 
